﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Configuration;
using System.Text;
using System.Collections;
using Xiaov.SmartWeb.Application.SupCan;

namespace Xiaov.SmartWeb.Application.HXZB.Tzfx
{
    public partial class XmyxdbGcmxData : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            string dataString = ConfigurationManager.AppSettings["XmyxdbGxmc_Column"];
            int nf = DateTime.Now.Year;
            int yf = DateTime.Now.Month;
            string zbbm = "";
            if (Request.QueryString["nf"] != "" && Request.QueryString["yf"] != "")
            {
                nf = Convert.ToInt32(Request.QueryString["nf"]);
                yf = Convert.ToInt32(Request.QueryString["yf"]);
            }
            if (Request.QueryString["zbbm"] != "")
            {
                zbbm = Request.QueryString["zbbm"];
            }

            string sSql = "select " + dataString + " from v_cj_yt_tzzb where nf =" + nf + " and yf=" + yf + " and xmgcid='" + zbbm + "'";
            DataSet ds = Maticsoft.DBUtility.DbHelperOra.Query(sSql);

            #region 输出数据
            ConvertToXml.Convert(ds.Tables[0], dataString, 0, ds.Tables[0].Rows.Count);
            #endregion
        }
    }
}